package com.cxhome.cxinfox.productvas;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;
import com.traffic.managent.annotation.ModelBind;
import com.traffic.managent.base.SessionUser;

@ModelBind(table = "cx_product_vasproduct", key = "ids")
public class ProductVasproduct extends SessionUser<ProductVasproduct> {

	private static final long serialVersionUID = 1L;
	public static final ProductVasproduct dao = new ProductVasproduct();
	
	/**
	 * 获取已经绑定的供应商
	 */
	public Record getBindedPid(String vasPid) {
		String sql = "select group_concat(pid) as pid from cx_product_vasproduct cpv where cpv .vasPid = ?";
		Record record = Db.findFirst(sql, vasPid);
		return record;

	}
	
}
